Oracle Database 11g: SQL Fundamentals I

This course is designed for application developers with basic SQL language skills. In this course, students learn to control privileges at the object and system level. This course covers creating indexes and constraints, and altering existing schema objects. Students also learn to create and query external tables and use the advanced features of SQL to query and manipulate data within the database.
Students learn to use the dictionary views to retrieve metadata and create reports about their schema objects. Students learn some of the date time functions available in the Oracle 11g Database and use the regular expression support in SQL.
In this course, students use Oracle SQL Developer as the main tool and SQL*Plus is introduced as an optional tool.
This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement.
This is appropriate for a 10g audience too. There are few minor changes between 10g and 11g features.

Learn To:

Control database access to specific objects
Manage schema objects and use data dictionary views
Manipulate large data sets in the Oracle database by using subqueries
Manage data in different time zones
Retrieve data by using advanced subqueries
Use the regular expression support in SQL to search, match, and replace strings in terms of regular expressions

12 courses found

- Delivery Format: Public Classroom
- Date 07-09 July, 2025
- Location: Dubai-Knowledge Village
$1,681.00
- Delivery Format: Virtual Learning
- Date 07-09 July, 2025
- Location: Virtual
$1,681.00
- Delivery Format: Public Classroom
- Date 04-06 August, 2025
- Location: Dubai-Knowledge Village
$1,681.00
- Delivery Format: Virtual Learning
- Date 04-06 August, 2025
- Location: Virtual
$1,681.00
- Delivery Format: Public Classroom
- Date 01-03 September, 2025
- Location: Dubai-Knowledge Village
$1,681.00
- Delivery Format: Virtual Learning
- Date 01-03 September, 2025
- Location: Virtual
$1,681.00
- Delivery Format: Public Classroom
- Date 06-08 October, 2025
- Location: Dubai-Knowledge Village
$1,681.00
- Delivery Format: Virtual Learning
- Date 06-08 October, 2025
- Location: Virtual
$1,681.00
- Delivery Format: Public Classroom
- Date 03-05 November, 2025
- Location: Dubai-Knowledge Village
$1,681.00
- Delivery Format: Virtual Learning
- Date 03-05 November, 2025
- Location: Virtual
$1,681.00